-- @owner: @zou_jialiang050
-- @date: 2022-05-11
-- @testpoint: 给表插数据使用序列多插入几行序列nextval值

--step1:建序列;expect:成功
drop sequence if exists s_FVT_INSERT_0007;
create sequence s_FVT_INSERT_0007 increment by 1 start with 1;

--step2:建表;expect:成功
drop table if exists t_FVT_INSERT_0007;
create table t_FVT_INSERT_0007(id number,qq number,ww number) with (storage_type=ustore);

--step3:给表插数据使用序列多插入几行序列nextval值;expect:成功
insert into t_FVT_INSERT_0007 values(s_FVT_INSERT_0007.nextval,1,1),(s_FVT_INSERT_0007.nextval,2,2),
(s_FVT_INSERT_0007.nextval,3,3),(s_FVT_INSERT_0007.nextval,4,4);

--step4:查看表数据;expect:成功
select * from t_FVT_INSERT_0007;

--step5:环境清理;expect:成功
drop table t_FVT_INSERT_0007;
drop sequence s_FVT_INSERT_0007;